Personal SQL Version 2.0
USER GUIDE
Copyright © Azril Studio 2000 - 2001. All rights Reserved.
Personal SQL version 2.0 has better to offer. Please read on the section What's New In version 2.0

This program is designed to help people to learn SQL inexpensive way. PSQL is an independent SQL interpreter. It means you do not have run on any database to get queries result. Since PSQL has its own database jet system, users are not required to log into an SQL server or make any ODBC connection, for the purpose of learn how to code SQL.

However, for those who has advance knowledge on database, they can use PSQL as a portal to connect to existing ODBC or any supported ISAM type database to do extensive queries. In addition with several other database manipulation tools offered, definitely PSQL is one of the best database tools for new, intermediate and advance users.

Thank You for using Personal SQL (PSQL) version 2.0. I hope you all will have fun with it as well as I am coding it.


For more information please follow the link below:

 

 

GETTING STARTED :: WHAT'S NEW IN VERSION 2.0 [top]

  1. Add-on capabilities to connect to ODBC and ISAM type database; MS Access, Dbase, Paradox, etc

  2. Add-on capabilities to create, edit and delete ODBC/ISAM DSN Connection.

  3. Improved database explorer and data structure capabilities.

  4. Improved SQL interpreter engine both performance and speed.

 

GETTING STARTED :: PSQL vs OTHER ODBC TOOLS [top]

  1. PSQL is an interactive SQL program that helps people to learn how to code SQL the most flexible and inexpensive way. PSQL is powered by its own Jet Engine, therefore allows user to do practice SQL coding right on their computer without making any ODBC connection.

  2. In addition to that, PSQL also is a great tools for advance users. With PSQL, users can have choices to used the default PSQL database or connect to other ODBC or ISAM type databases. This makes it a particularly useful program for anyone dealing with databases from different sources, as it lets you manage all databases via a single user interface. 

  3. Above all, PSQL offer among the best and cleanest designed interface displays a tree view of the tables and views within the database, ODBC driver information, and many more. PSQL also offers the capabilities to generate scripts for many type of databases. You can either print it or save it!

  4. PSQL offer user to import/export tables and data into and from various databases format within minutes.

  5. PSQL Database Explorer and Structure give an definitive each for user to get every each database, tables, fields and records attributes and properties with just a click of a mouse.

  6. PSQL offer reasonable price with extraordinary capabilities database manipulation tools

 

GETTING STARTED :: INSTALLATION REQUIREMENTS [top]
Its recommend you unpack and run the installation procedures. This Installation Manager Will Tell You What Are The Recommended Requirements You Are Missing. 

  1. Windows 95/98/NT/2000 (DCOM 98 is required for WIN95)
  2. Pentium 166Mhz, 64MB - Minimum
  3. 5 MB of Hard Drive Space
  4. Microsoft Universal Data Access 2.5++ |Download Here|
  5. The latest Microsoft Installer |Download Here|

 

GETTING STARTED :: INSTALLATION GUIDELINES [top]

  1. Unpack PSQL2.zip using WinZip  or any other Unzip Tools
  2. Double click PSQL2.msi
    If you unable to install, you required to download Microsoft Installer here.
  3. During Installation, if the setup process indicates you do not have Microsoft Universal Data Access 2.5,
    Please Download Here. This Service Contains Latest Info regarding ISAM and ODBC databases supported by
    on Microsoft Windows platform.
  4. You will be required to RESTART you computer after the installation.
  5. Double click PSQL2 icon on your desktop to begin new session

 

GETTING STARTED :: HOW TO REGISTER [top]

PSQL v2.0 is a shareware. You have 60 trials time to use it before required to register. If you continue to use this application, or would like to have the shareware limitation removed you are required to register this product.

PSQL registration cost only $10.99 per user. After a successful registration, you will be sent the registration code which you can enter in the application's 'About' box, to unleash the full power of PSQL. The registration code will continue to work in newer versions of PSQL, it means all registered user will get free update.

All payment can be made using on of the methods below. We authorized DIGIBUY.COM to collect your payment on behalf of Azril Studio.

Online Credit Card Ordering = $10.99
FAX Credit Card Ordering = $10.99 + $1.00 processing fee
PHONE Credit Card Ordering = $10.99 + $1.00 processing fee
CHECK By Mail Ordering = $10.99 + $3.00 processing fee
PO Ordering = $10.99 + $10.00 processing fee

To purchase registration license, click here.
Please follow all the instructions and proceed with the method of
payment of your choice.

WORKSPACE OPERATIONS :: MAIN MENU WINDOW [top]
PSQL Main Menu Window is the main interface for user to interact with PSQL system. Below is the definite overview on PSQL Main Menu Window

 

WORKSPACE OPERATIONS :: SQL CODE WINDOW [top]
SQL Code Window is the interface where the user will write the SQL codes prior submitting to PSQL interpreter for processing. For more information how to write the SQL code, please refer to creating new query section.

 

WORKSPACE OPERATIONS :: QUERY RESULT WINDOW [top]
Query Result Window is the interface where user view all the output from the SQL codes that have been compiled by PSQL.

 

WORKSPACE OPERATIONS :: DATA EXPLORER/STRUCTURE WINDOW [top]
Data Explorer / Structure window is the interface where user can view database attributes such tables and records. User also can use this interface to get all database information and properties. Please go here to learn more how to explore and to retrieve information from database explorer / structure window.

 

WORKSPACE OPERATIONS :: ODBC/ISAM CONNECTION WINDOW [top]
ODBC/ISAM Connection Window is the interface for user to create, edit and open connection to a ODBC or ISAM type database. Click here to for more information on how to OPEN, EDIT and CREATE a connection to ODBC/ISAM Type Database.

 

HOW TO :: CREATING NEW QUERY [top]
For this tutorial, we will used the default PSQL Database:-
We are going to create a new table called STUDENT and populated it with several records. Please follow the instruction to create your new database and SQL query.

  1. Click on the FILE MENU and select NEW SCRIPT, or Click The New Script Shortcut Button.

    If you decided to rewrite the script, follow this example; or just cut and paste
    Create table STUDENT (Student_ID INTEGER UNIQUE, Student_Name TEXT(20), Student_Status TEXT(20));

    INSERT INTO STUDENT VALUES (1,’JOHN DOE’,’FRESHMAN’);
    INSERT INTO STUDENT VALUES (2,’JOHN DENVER’,’SOPHOMORE’);
    INSERT INTO STUDENT VALUES (3,’TONI BRAXTON’,’JUNIOR’);
    INSERT INTO STUDENT VALUES (4,’JOHN MALKOVICH’,’SENIOR’);


    Using above script, we will create a table called STUDENT, with fields of STUDENT_ID, STUDENT_NAME and STUDENT_STATUS. Following codes, we insert each unique value into the STUDENT table. If you noticed on the STUDENT_ID field, there is a reserved keyword call UNIQUE. This keyword tell Personal SQL compiler to assign Primary Key to this particular Key. 

    Once you done entered the script into the text box, click the RUN button or press the F5 key to execute the codes. A result window will appear if the compilation of those codes is successful. If you get an error message, please check the codes you have pasted. The result window will list all the executed codes and its result.

    We now have a new table together with its contents to work on. 

    Click the View Menu of the Main Window, choose the DATABASE EXPLORER / DATA STRUCTURE WINDOW. A new window will pop-out and listing the tables and its fields that we have just created.

    Now we are ready to go to the next steps in this tutorial. Before that, click on the FILE MENU and choose new script. A message box will pop-out asking whether you wish to SAVE the script. It is recommended for you to save it for later references. Save it as script1.pst. 

    Once you that, a message box will appear to confirm the clear the current contents in the SQL text box. Go ahead and click YES.

    Click here to go to next level – Viewing Query Results

 

HOW TO :: VIEWING QUERY RESULTS [top]

Basic tutorial guidelines on how to viewing query result

Before we begin, we already have a table STUDENT created in previous tutorial section. If you missed it, please refer back to the Creating New Query Section.

To continue, copy the following code to the SQL Code Text Box and press the F5 Key after that. 
SELECT * FROM STUDENT;

Once you execute the code, a result window will appear listing the each field contents listed under table STUDENT.

Type or copy the following code and put it under the first code we just execute
SELECT STUDENT_ID, STUDENT_NAME FROM STUDENT;
SELECT STUDENT_NAME, STUDENT_STATUS FROM STUDENT;
SELECT * FROM STUDENT WHERE STUDENT_ID = 2;
SELECT * FROM STUDENT WHERE STUDENT_NAME = ‘John Denver’

Click the RUN BUTTON or F5 key to execute the following codes.

A new result window will appear with result from the codes you entered. From the result, you will have 5 different successful execute SQL code and its results.

If you wish to save the result, click the SAVE BUTTON.
If you wish to print it, click the PRINT BUTTON

 

 

HOW TO :: CONNECTING TO AN ODBC / ISAM DATABASE [top]

  1. Launch the ODBC/ISAM Connection Window.

  2. You have 2 choices, you can connect to PSQL default database or attempt to make connection to ODBC/ISAM database.

  3. To connect into ODBC/ISAM database, select the ODBC/ISAM connection radio button.

  4. Select the DSN name from the list box.

  5. Enter your password and USERID, and click OK.

  6. Click here for more information on how to create and edit ODBC/ISAM connection.

 

HOW TO :: CREATING NEW ODBC / ISAM DSN [top]
Depending on your needs you can decide what type of DNS would be suitable for you. In the example below we will create a System DSN that will point to an MS SQL Server database.

  • The 1st step is to launch the ODBC/ISAM Connection Window.
  • Then Select ODBC/ISAM Connection Radio Button.
  • Click On The Create New Connection, and Microsoft ODBC Manager will appear.
    Before proceed, there 3 different DSN types. For more info regarding this types, click here


Click on the System DSN tab in the Data Source Administrator

  • Click the Add… button to add a new DSN.

  • The next screen will display all the available ODBC drivers that you have installed on the machine. For this example, select SQL Server.


Please note that screen in the next step may differ from driver to driver. 
For this example we are using version 2.65 of Microsoft SQL Server driver.

  • Click the Ok button when done.

 

HOW TO :: EDITING EXISTING ODBC / ISAM DSN [top]

To edit existing ODBC / ISAM DSN, please follow the following steps:-

  1. Open the ODBC/ISAM Connection interface.

  2. Select the ODBC/ISAM connection radio button.

  3. Select the exact DSN name you wish to edit from the lists.

  4. Click the Edit Existing Connection button

  5. Follow the steps at documented in the ODBC Database Administrator

 

HOW TO :: RETRIEVING DATABASE, TABLES, RECORDS & FIELDS ATTRIBUTES/PROPERTIES INFO [top]

  1. To retrieve information about a database, launch the database explorer / data structure window

  2. You can select any section of the database and right click your mouse button.

  3. A popup menu will appear next to the selected item. 

  4. Click the appropriate command to proceed.

  5. Command Information:-

    View All Records Pertain To This Table.
    This will list all the records that available under the selected table. This command will only works
    if you select a table.


    Properties
    This will view all the attributes and properties for each database, tables and fields.

 

APPENDIX :: PSQL JET LANGUAGE REFERENCES [top]
PSQL Jet Language references is designed for all users that is using PSQL database to do queries. Intensive language references is available in the PSQLJET help file.

PSQLJET Help file is available under the HELP directory.

 

 

APPENDIX :: ODBC / ISAM TYPE DATABASE LANGUAGE REFERENCES [top]
ODBC and ISAM language references are vary between provider. For example queries commands for MySQL is different from conventional Oracle or Sybase. However basic SQL syntaxes are standard. Many database provider will try to make their databases to be outstanding to other types by offering more data storage / manipulation capabilities. Due to this differences, you may want to obtain further information regarding advance queries on specific database type.

Users can applied PSQL Jet language reference if opening TXT or HTML type databases.

Below is the list of popular ODBC and ISAM type database provider. Please go to their website to do extensive search on specific database type language reference.

ISAM PROVIDER

ODBC PROVIDER
Microsoft
Access 2.0,7.0,97,2000
HTML, Outlook, Excel, Foxpro.

Dbase
Dbase 5.0, IV, III

Paradox (Corel)
Paradox 5.0, 4.x, 3.x

LOTUS
Lotus 123, WK1, WK2

 

 MySQL

Sybase

Microsoft

Oracle

GNU Compatible

APPENDIX :: ODBC / ISAM DSN CONNECTION TYPES INFO [top]
You can create three different kinds of data source names.

DSN TYPE

  DESCRIPTION
User DSN These data sources are local to a computer, and may only be used by the current user.
System DSN These data sources are local to a computer, rather than dedicated to a user. The system, or any user having privileges, can use a data source set up with a system DSN.
File DSN These are file-based data sources that may be shared between all users that have the same drivers installed, so have access to the database. These data sources are not dedicated to a user and are not machine specific. 

 

 

APPENDIX :: PSQL vs ODBC vs ISAM DATABASE TYPE [top]

Below is the explanation between PSQL, ODBC and ISAM type

Database Type Explaination
PSQL PSQL is special designed database that used MS Access 2.0 technology features. Its design to run on version 3.0 Microsoft Jet engine. PSQL is simple database that accept standard ANSI SQL command types. It is very small. Primarily, PSQL is meant for beginner to learn SQL codes syntaxes. PSQL is not for commercial usage. Users can open, delete, alter, import/export and convert PSQL database in any formats.
ODBC Abbreviation of Open DataBase Connectivity, a standard database access method developed by Microsoft Corporation. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver , between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Since version 2.0, the standard supports SAG SQL. 
ISAM Abbreviation for Indexed Sequential Access Method, a method for managing how a computer accesses records and files stored on a hard disk. While storing data sequentially, ISAM provides direct access to specific records through an index. This combination results in quick data access regardless of whether records are being accessed sequentially or randomly. 

There are a number of products that provide basic ISAM access for different operating systems and program languages. 

 

 

APPENDIX :: SYSTEM TROUBLESHOOTING FAQs [top]

Why I cannot run after I installed the program on the network?
The system administrator to prevent unauthorized user, deleting or damaging the computer files may have disabled Computer attached to the network. Usually the system admin prefers to disable the Windows system directory. Since Personal SQL need to access the directory while running, prevent it may result failure. Please check with your system administrator.You may need to update to the latest system installer. Please see the system requirements section on how to get the entire latest PSQL software companions. 

Why as soon as I installed, the program would run, and give an error message
Probably the installation package files is corrupted. Please download a new one, and then try again.

When I try to run the program, it gave an error message “System Error”
This tells you that your registry system is corrupted or someone tampered with registry system. Please uninstall the program before attempt to reinstall it. The program should be OK to go after you reinstall. If you own a registered version, please copy you name and key for later use, to undo the unregistered version. Its recommend you uninstall the current program in order to give new installation a clean environment.

Everything are fine except when I try to do the queries, instead giving me result if give me errors although I am positive my code is syntax error free.
This problem usually occurs when the PSQLJET file dynamic lick library does not communicate very efficient with Window 98/NT Jet Data. If you are using Win95, it will not work because this program is designed to run under WIN98/NT4.0 and above version. However if you run under WIN98/NT4.0, please run the MDAC_TYP.EXE stored under Personal SQL directory. This is will update your system with the latest Jet Data. 

I have already installed the MDAC_TYP.EXE; still the program is not working properly.
Run the Dcomp98.exe under Personal SQL program directory, and then install the MDAC_TYP.EXE

I did install both Dcomp98 and MDAC_TYP files, and its still give the same problem
Please reinstall the Personal SQL program. If you own a registered version, please copy you name and key for later use, to undo the unregistered version. Its recommend you uninstall the current program in order to give new installation a clean environment.

What if all questions above is not the answer I’m looking for
You can forward the question online. The response may take up to 48 hour depending on the task need to be solved. If the question is forward in between 9am – 4pm CST and the question is straight forward, you might get the feedback within 1 to 2 hours. Please also go to the http://www.azril.com/azrilstudio/supportmail.asp to forward you questions.

 

 

 

 

 

 

 

 

 

Copyright © 2000 - 2001 Azril Studio
All rights Reserved
Other corporation pattern mentioned are pending to their own trademark